<!DOCTYPE html>
<html lang="en">
<head>

    <!-- 页面meta -->
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>学校管理系统</title>
    <link rel="icon"
          href="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1596120245889&di=5093bcb814a73039583d935c56ee7213&imgtype=0&src=http%3A%2F%2Fen.pimg.jp%2F041%2F867%2F367%2F1%2F41867367.jpg"/>
    <meta name="description" content="AdminLTE2定制版">
    <meta name="keywords" content="AdminLTE2定制版">

    <!-- 页面头部引用 -->
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no" name="viewport">
    <!-- Bootstrap 3.3.6 -->
    <!-- Font Awesome -->
    <!-- Ionicons -->
    <!-- iCheck -->
    <!-- Morris chart -->
    <!-- jvectormap -->
    <!-- Date Picker -->
    <!-- Daterange picker -->
    <!-- Bootstrap time Picker -->
    <!--<link rel="stylesheet" type="text/css" href="./././plugins/timepicker/bootstrap-timepicker.min.css">-->
    <!-- bootstrap wysihtml5 - text editor -->
    <!--数据表格-->
    <!-- 表格树 -->
    <!-- select2 -->
    <!-- Bootstrap Color Picker -->
    <!-- bootstrap wysihtml5 - text editor -->
    <!--bootstrap-markdown-->
    <!-- Theme style -->
    <!-- AdminLTE Skins. Choose a skin from the css/skins
    folder instead of downloading all of them to reduce the load. -->
    <!-- Ion Slider -->
    <!-- ion slider Nice -->
    <!-- bootstrap slider -->
    <!-- bootstrap-datetimepicker -->

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
    <!-- jQuery 2.2.3 -->
    <!-- jQuery UI 1.11.4 -->
    <!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
    <!-- Bootstrap 3.3.6 -->
    <!-- Morris.js charts -->
    <!-- Sparkline -->
    <!-- jvectormap -->
    <!-- jQuery Knob Chart -->
    <!-- daterangepicker -->
    <!-- datepicker -->
    <!-- Bootstrap WYSIHTML5 -->
    <!-- Slimscroll -->
    <!-- FastClick -->
    <!-- iCheck -->
    <!-- AdminLTE App -->
    <!-- 表格树 -->
    <!-- select2 -->
    <!-- bootstrap color picker -->
    <!-- bootstrap time picker -->
    <!--<script src="./././plugins/timepicker/bootstrap-timepicker.min.js"></script>-->
    <!-- Bootstrap WYSIHTML5 -->
    <!--bootstrap-markdown-->
    <!-- CK Editor -->
    <!-- InputMask -->
    <!-- DataTables -->
    <!-- ChartJS 1.0.1 -->
    <!-- FLOT CHARTS -->
    <!-- FLOT RESIZE PLUGIN - allows the chart to redraw when the window is resized -->
    <!-- FLOT PIE PLUGIN - also used to draw donut charts -->
    <!-- FLOT CATEGORIES PLUGIN - Used to draw bar charts -->
    <!-- jQuery Knob -->
    <!-- Sparkline -->
    <!-- Morris.js charts -->
    <!-- Ion Slider -->
    <!-- Bootstrap slider -->
    <!-- bootstrap-datetimepicker -->
    <!-- 页面meta /-->
    <link rel="stylesheet" type="text/css" href="../plugins/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="../plugins/font-awesome/css/font-awesome.min.css">
    <link rel="stylesheet" type="text/css" href="../plugins/ionicons/css/ionicons.min.css">
    <link rel="stylesheet" type="text/css" href="../plugins/iCheck/square/blue.css">
    <link rel="stylesheet" type="text/css" href="../plugins/morris/morris.css">
    <link rel="stylesheet" type="text/css" href="../plugins/jvectormap/jquery-jvectormap-1.2.2.css">
    <link rel="stylesheet" type="text/css" href="../plugins/datepicker/datepicker3.css">
    <link rel="stylesheet" type="text/css" href="../plugins/daterangepicker/daterangepicker.css">
    <link rel="stylesheet" type="text/css" href="../plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css">
    <link rel="stylesheet" type="text/css" href="../plugins/datatables/dataTables.bootstrap.css">
    <link rel="stylesheet" type="text/css" href="../plugins/treeTable/jquery.treetable.css">
    <link rel="stylesheet" type="text/css" href="../plugins/treeTable/jquery.treetable.theme.default.css">
    <link rel="stylesheet" type="text/css" href="../plugins/select2/select2.css">
    <link rel="stylesheet" type="text/css" href="../plugins/colorpicker/bootstrap-colorpicker.min.css">
    <link rel="stylesheet" type="text/css" href="../plugins/bootstrap-markdown/css/bootstrap-markdown.min.css">
    <link rel="stylesheet" type="text/css" href="../plugins/adminLTE/css/AdminLTE.css">
    <link rel="stylesheet" type="text/css" href="../plugins/adminLTE/css/skins/_all-skins.min.css">
    <link rel="stylesheet" type="text/css" href="../css/style.css">
    <link rel="stylesheet" type="text/css" href="../plugins/ionslider/ion.rangeSlider.css">
    <link rel="stylesheet" type="text/css" href="../plugins/ionslider/ion.rangeSlider.skinNice.css">
    <link rel="stylesheet" type="text/css" href="../plugins/bootstrap-slider/slider.css">
    <link rel="stylesheet" type="text/css" href="../plugins/bootstrap-datetimepicker/bootstrap-datetimepicker.css">
    <!-- 页面头部引用 /-->
</head>

<body class="hold-transition skin-purple sidebar-mini">

<div class="wrapper">

    <!-- 页面头部 -->
    <header class="main-header">
        <!-- Logo -->
        <a href="#" class="logo">
            <!-- mini logo for sidebar mini 50x50 pixels -->
            <span class="logo-mini"><b>学校</b></span>
            <!-- logo for regular state and mobile devices -->
            <span class="logo-lg"><b>学校</b>后台管理系统</span>
        </a>


        <!-- Header Navbar: style can be found in header.less -->
        <nav class="navbar navbar-static-top">
            <!-- Sidebar toggle button-->
            <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
                <span class="sr-only">Toggle navigation</span>
            </a>
            <div class="navbar-custom-menu">
                <ul class="nav navbar-nav">
                    <!-- Messages: style can be found in dropdown.less-->
                    <li class="dropdown messages-menu">
                        <!--                            &lt;!&ndash; Menu Footer&ndash;&gt;-->
                        <!--                            <li class="user-footer">-->
                        <!--                                <div class="pull-left">-->
                        <!--                                    <a href="#" class="btn btn-default btn-flat">修改密码</a>-->
                        <!--                                </div>-->
                        <!--                                <div class="pull-right">-->
                        <!--                                    <a href="s_login/loginOut.jsp" class="btn btn-default btn-flat">注销</a>-->
                        <!--                                </div>-->
                        <!--                            </li>-->
                </ul>
                </li>

                </ul>
            </div>
        </nav>
    </header>
    <!-- 页面头部 /-->

    <!-- 导航侧栏 -->
    <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
        <section class="sidebar">
            <!-- Sidebar user panel -->
            <div class="user-panel">
                <div class="pull-left image">
                    <img src="../img/user2-160x160.jpg" class="img-circle" alt="User Image">
                </div>
                <div class="pull-left info">
                    <a href="#"><i class="fa fa-circle text-success"></i> 在线</a>
                </div>
            </div>
            <!-- search form -->
            <!--<form action="#" method="get" class="sidebar-form">
        <div class="input-group">
            <input type="text" name="q" class="form-control" placeholder="搜索...">
            <span class="input-group-btn">
            <button type="submit" name="search" id="search-btn" class="btn btn-flat"><i class="fa fa-search"></i>
            </button>
          </span>
        </div>
    </form>-->
            <!-- /.search form -->


            <!-- sidebar menu: : style can be found in sidebar.less -->
            <ul class="sidebar-menu">
                <li class="header">菜单</li>

                <li id="admin-index"><a href="../index.jsp"><i class="fa fa-bank"></i> <span>首页</span></a></li>

                <!-- 菜单 -->
                <!-- 学生侧栏 -->
                <li class="treeview">
                    <a href="#">
                        <i class="fa fa-male"></i> <span>学生信息管理</span>
                        <span class="pull-right-container">
                        <i class="fa fa-angle-left pull-right"></i>
                    </span>
                    </a>
                    <ul class="treeview-menu">

                        <li id="addStu">
                            <a href="../s_student/s_studentAdd.html">
                                <i class="fa fa-circle-o"></i> 增加学生信息
                            </a>
                        </li>

                        <li id="stuInfo">
                            <a href="../s_student/s_studentInfo.html">
                                <i class="fa fa-circle-o"></i> 查看学生信息
                            </a>
                        </li>
                    </ul>
                </li>

                <!-- 年级侧栏 -->
                <li class="treeview">
                    <a href="#">
                        <i class="fa fa-folder"></i> <span>年级信息管理</span>
                        <span class="pull-right-container">
                        <i class="fa fa-angle-left pull-right"></i>
                    </span>
                    </a>
                    <ul class="treeview-menu">

                        <li id="addGrade">
                            <a href="../s_grade/s_gradeAdd.jsp">
                                <i class="fa fa-circle-o"></i> 增加年级信息
                            </a>
                        </li>
                        <li id="infoGrade">
                            <a href="../s_grade/s_gradeInfo.jsp">
                                <i class="fa fa-circle-o"></i> 查看年级信息
                            </a>
                        </li>


                    </ul>
                </li>

                <!-- 课程侧栏 -->
                <li class="treeview">
                    <a href="#">
                        <i class="fa fa-calendar"></i> <span>课程信息管理</span>
                        <span class="pull-right-container">
                        <i class="fa fa-angle-left pull-right"></i>
                    </span>
                    </a>
                    <ul class="treeview-menu">

                        <li id="addSub">
                            <a href="../s_subject/s_subjectAdd.jsp">
                                <i class="fa fa-circle-o"></i> 增加课程信息
                            </a>
                        </li>

                        <li id="infoSub">
                            <a href="../s_subject/s_subjectInfo.jsp">
                                <i class="fa fa-circle-o"></i> 查看课程信息
                            </a>
                        </li>


                    </ul>
                </li>

                <!-- 成绩侧栏 -->
                <li class="treeview">
                    <a href="#">
                        <i class="fa fa-pencil"></i> <span>成绩信息管理</span>
                        <span class="pull-right-container">
                        <i class="fa fa-angle-left pull-right"></i>
                    </span>
                    </a>
                    <ul class="treeview-menu">

                        <li id="addScore">
                            <a href="s_exResultAdd.html">
                                <i class="fa fa-circle-o"></i> 增加成绩信息
                            </a>
                        </li>
                        <li id="infoScore">
                            <a href="s_examInfo.html">
                                <i class="fa fa-circle-o"></i> 查看成绩信息
                            </a>
                        </li>


                    </ul>
                </li>


                <!-- 菜单 /-->

                <li id="admin-documentation"><a href="#" target="_blank"><i class="fa fa-book"></i>
                    <span>学生系统帮助文档</span></a></li>

            </ul>
        </section>
        <!-- /.sidebar -->
    </aside>
    <!-- 导航侧栏 /-->

    <!-- 内容区域 -->
    <!-- @@master = admin-layout.html-->
    <!-- @@block = content -->

    <div class="content-wrapper">

        <!-- 内容头部 -->
        <section class="content-header">
            <h1>
                成绩信息管理
                <small>查看成绩信息</small>
            </h1>
            <ol class="breadcrumb">
                <li><a href="#"><i class="fa fa-dashboard"></i>首页</a></li>
                <li><a href="#">成绩信息管理</a></li>
                <li class="active">查看成绩信息</li>
            </ol>
        </section>
        <!-- 内容头部 /-->

        <!-- 正文区域 -->
        <section class="content">

            <div class="box box-primary">
                <div class="box-header with-border">
                    <h3 class="box-title">欢迎登陆学校信息后台管理系统</h3>
                </div>

                <div class="box-body">

                    您可以在这里查看成绩信息<br> 如果需要帮助的话请点击侧边栏下方的帮助文档

                </div>
                <!--查看信息-->
                <div class="box">
                    <div class="box-header">
                        <h3 class="box-title">查看成绩信息</h3>
                    </div>
                    <!-- .box-body -->
                    <div class="box box-primary">
                        <div class="box-header with-border">
                            <h3 class="box-title">成绩列表</h3>
                        </div>

                        <div class="box-body">

                            <!-- 数据表格 -->
                            <div class="table-box">

                                <!--工具栏-->
                                <div class="pull-left">
                                    <div class="form-group form-inline">
                                        <div class="btn-group">
<!--                                            <a href="s_studentAdd.html">-->
<!--                                                <button type="button" class="btn btn-default" title="增加学生"><i-->
<!--                                                        class="fa fa-file-o"></i> 增加学生-->
<!--                                                </button>-->
<!--                                            </a>-->
                                            <a href="../s_examResult/s_exResultAdd.html">
                                                <button type="button" class="btn btn-default" title="增加成绩"><i
                                                        class="fa fa-file-o"></i> 增加成绩
                                                </button>
                                            </a>
                                        </div>
                                    </div>
                                </div>

<!--                                <div class="input-group input-group-sm" style="float: right">-->
<!--                                    <form id="searchForm">-->
<!--                                        <input type="text" class="form-control " style="width: 100px;"-->
<!--                                               placeholder="按姓名查询" name="sname">-->
<!--                                        <input type="text" class="form-control " style="width: 100px;"-->
<!--                                               placeholder="按电话查询" name="telephone">-->
<!--                                        <input type="text" class="form-control " style="width: 100px;"-->
<!--                                               placeholder="按微信查询" name="wechat">-->
<!--                                        <select class="form-control" style="width: 130px;" name="stuGrade" id="gradeSelect">-->
<!--                                            <option  selected="selected" value="">全部年级</option>-->
<!--                                        </select>-->
<!--                                        <span class="input-group-btn">-->
<!--                                                <button id="search" type="button"-->
<!--                                                        class="btn btn-info btn-flat">搜索</button>-->
<!--                                             </span>-->
<!--                                    </form>-->
<!--                                </div>-->

                                <!--工具栏/-->


                                <!--数据列表-->
                                <table id="dataList" class="table table-bordered table-striped table-hover dataTable">
                                    <thead>
                                    <tr>
                                        <!--                                        <th class="" style="padding-right:0px;">-->
                                        <!--                                            <input id="selall" type="checkbox" class="icheckbox_square-blue">-->
                                        <!--                                        </th>-->
                                        <th>成绩编号</th>
                                        <th>考生ID</th>
                                        <th>考生姓名</th>
                                        <th>科目ID</th>
                                        <th>科目名称</th>
                                        <th>考试分数</th>
                                        <th>考试时间</th>
                                        <th>操作</th>
                                    </tr>
                                    </thead>
                                    <tbody>


                                    </tbody>
                                </table>
                                <!--数据列表/-->


                            </div>
                            <!-- 数据表格 /-->


                        </div>
                        <!-- /.box-body -->

                        <!-- .box-footer-->
                        <div class="box-footer">
                            <div class="box-tools pull-right">
                                <ul class="pagination">
                                    <li><a href="#" aria-label="Previous" id="first">首页</a></li>
                                    <li><a href="#" id="prev">上一页</a></li>
                                    <li><a href="#" id="next">下一页</a></li>
                                    <li><a href="#" aria-label="Next" id="last">尾页</a></li>
                                </ul>

                            </div>

                        </div>
                        <!-- /.box-footer-->
                    </div>
                </div>

            </div>

        </section>
        <!-- 正文区域 /-->

    </div>
    <!-- @@close -->
    <!-- 内容区域 /-->

    <!-- 增加学生  -->
    <!-- 增加学生 /-->

    <!-- 底部导航 -->
    <footer class="main-footer">
        <div class="pull-right hidden-xs">
            <b>Version</b> 1.0.8
        </div>
        <strong>Copyright &copy; 1999-2020 <a href="#">合肥市炎谨软件有限公司·研发部</a>.</strong> All rights reserved.
    </footer>
    <!-- 底部导航 /-->

</div>
<!-- 页面尾部引用 -->
<script src="../plugins/jQuery/jquery-2.2.3.min.js"></script>
<script src="../plugins/jQueryUI/jquery-ui.min.js"></script>
<script>
    $.widget.bridge('uibutton', $.ui.button);
</script>
<script src="../plugins/bootstrap/js/bootstrap.min.js"></script>
<script src="../plugins/raphael/raphael-min.js"></script>
<script src="../plugins/morris/morris.min.js"></script>
<script src="../plugins/sparkline/jquery.sparkline.min.js"></script>
<script src="../plugins/jvectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="../plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
<script src="../plugins/knob/jquery.knob.js"></script>
<script src="../plugins/daterangepicker/moment.min.js"></script>
<script src="../plugins/daterangepicker/daterangepicker.js"></script>
<script src="../plugins/daterangepicker/daterangepicker.zh-CN.js"></script>
<script src="../plugins/datepicker/bootstrap-datepicker.js"></script>
<script src="../plugins/datepicker/locales/bootstrap-datepicker.zh-CN.js"></script>
<script src="../plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script>
<script src="../plugins/slimScroll/jquery.slimscroll.min.js"></script>
<script src="../plugins/fastclick/fastclick.js"></script>
<script src="../plugins/iCheck/icheck.min.js"></script>
<script src="../plugins/adminLTE/js/app.min.js"></script>
<script src="../plugins/treeTable/jquery.treetable.js"></script>
<script src="../plugins/select2/select2.full.min.js"></script>
<script src="../plugins/colorpicker/bootstrap-colorpicker.min.js"></script>
<script src="../plugins/bootstrap-wysihtml5/bootstrap-wysihtml5.zh-CN.js"></script>
<script src="../plugins/bootstrap-markdown/js/bootstrap-markdown.js"></script>
<script src="../plugins/bootstrap-markdown/locale/bootstrap-markdown.zh.js"></script>
<script src="../plugins/bootstrap-markdown/js/markdown.js"></script>
<script src="../plugins/bootstrap-markdown/js/to-markdown.js"></script>
<script src="../plugins/ckeditor/ckeditor.js"></script>
<script src="../plugins/input-mask/jquery.inputmask.js"></script>
<script src="../plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
<script src="../plugins/input-mask/jquery.inputmask.extensions.js"></script>
<script src="../plugins/datatables/jquery.dataTables.min.js"></script>
<script src="../plugins/datatables/dataTables.bootstrap.min.js"></script>
<script src="../plugins/chartjs/Chart.min.js"></script>
<script src="../plugins/flot/jquery.flot.min.js"></script>
<script src="../plugins/flot/jquery.flot.resize.min.js"></script>
<script src="../plugins/flot/jquery.flot.pie.min.js"></script>
<script src="../plugins/flot/jquery.flot.categories.min.js"></script>
<script src="../plugins/ionslider/ion.rangeSlider.min.js"></script>
<script src="../plugins/bootstrap-slider/bootstrap-slider.js"></script>
<script src="../plugins/bootstrap-datetimepicker/bootstrap-datetimepicker.js"></script>
<script src="../plugins/bootstrap-datetimepicker/locales/bootstrap-datetimepicker.zh-CN.js"></script>
<!-- 页面尾部引用 /-->
<!--<script src="../js/jquery-1.12.4.min.js"></script>-->
<script>

    <!--年级下拉-->
    $(function (){
        let grade=$("#gradeSelect");
        $.post("/myWeb_war_exploded/GradeServlet",function (data) {
            $.each(data,function (index,obj) {
                grade.append("<option value="+obj.id+">"+obj.id+"-"+obj.gname+"</option>");
            });
        });
    });


    function doDel(name, id) {
        if (confirm("是否确认删除[" + id + "-" + name + "]？")) {
            location.href = "/myWeb_war_exploded/AdminLTEdemo01/s_student/doDelStudent.jsp?stuno=" + id;
        }
    }


    $(document).ready(function () {

        // 选择框
        $(".select2").select2();

        // WYSIHTML5编辑器
        $(".textarea").wysihtml5({
            locale: 'zh-CN'
        });
    });


    // 设置激活菜单
    function setSidebarActive(tagUri) {
        var liObj = $("#" + tagUri);
        if (liObj.length > 0) {
            liObj.parent().parent().addClass("active");
            liObj.addClass("active");
        }
    }


    //定位
    $(document).ready(function () {
        setSidebarActive("stuInfo");
    });

    //读取JSON数据
    $(function () {
        let pageNo = 1;
        var total = 1;
        var sname = "";
        var telephone = "";
        var t = $("#dataList");
        $("a#first").click(function () {
            pageNo = 1;
            load();
        });
        $("a#prev").click(function () {
            if (pageNo <= 1)
                return;
            pageNo--;
            load();
        });
        $("a#next").click(function () {
            if (pageNo >= total)
                return;
            pageNo++;
            load();
        });
        $("a#last").click(function () {
            pageNo = total;
            load();
        });


        function load() {
            t.find("tr:gt(0)").remove();
            // sname = $(":input[name=sname]").val();
            // telephone = $(":input[name=telephone]").val();
            // wechat = $(":input[name=wechat]").val();
            // stuGrade = $(":input[name=stuGrade]").val();
            $.get("/myWeb_war_exploded/exInfoServlet.ex", {
                "pageNo": pageNo
                // ,
                // "sname": sname,
                // "wechat": wechat,
                // "gradeid": stuGrade,
                // "telephone": telephone
            }, function (data) {
                total = data.pageNum;//外部的total赋值
                $.each(data.exDatas, function (i, d) {
                    t.append(
                        "<tbody><tr>" +
                        "<td>" + d.id + "</td>" +
                        "<td>" + d.stID + "</td>" +
                        "<td>" + d.student.sname + "</td>" +
                        "<td>" + d.sbID + "</td>" +
                        "<td>" + d.subject.subjectname + "</td>" +
                        "<td>" + d.score + "</td>" +
                        "<td>" + d.examDate + "</td>" +


                        // 修改删除查看按钮
                        "<td class=\"text-center\">\n" +
                        "<a href=\"/myWeb_war_exploded/toUpdateStudentServlet?stuno="+d.stuno+"\">\n" +
                        "<button type=\"button\" class=\"btn bg-olive btn-xs\">修改</button>\n" +
                        "</a>\n" +
                        "<a href=\"#\">\n" +
                        "<button type=\"button\" class=\"btn bg-olive btn-xs\"\n" +
                        "onclick=\"doDel('"+d.sname+"',"+d.stuno+");return false;\">删除\n" +
                        "</button>\n" +
                        "</a>\n" +
                        "\n" +
                        " <a href=\"/myWeb_war_exploded/doStudentInfoShowServlet?stuno="+d.stuno+"\">\n" +
                        "<button type=\"button\" class=\"btn bg-olive btn-xs\">查看</button>\n" +
                        "</a>\n" +
                        "</td>"+

                        "</tr></tbody>"

                    );


                });
            });
        }

        load();

        // $("#search").click(function () {
        //     sname = $("input[name=sname]").val();
        //     telephone = $("input[name=telephone]").val();
        //     wechat = $("input[name=wechat]").val();
        //     stuGrade = $("input[name=stuGrade]").val();
        //     // alert(sname+"+"+telephone);
        //     load();
        // });
    });

</script>
</body>

</html>